package tgc.edu.exam.repository;

import java.util.List;
import java.util.UUID;

import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import tgc.edu.exam.custom.CommonRepository;
import tgc.edu.exam.entity.SysFile;
@Repository
public interface SysFileRepository extends CommonRepository<SysFile, Integer>{

	public SysFile findByUuid(String uuid);

	@Query(value="SELECT * FROM SYS_FILE WHERE IS_USED = 0",nativeQuery=true)
	public List<SysFile> findByIsUserd();

}
